﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace CRM.MODEL
{


    #region 存储过程 Pro_GetParts 的相关参数
    /// <summary>
    /// Pro_GetParts 的相关参数
    ///Parts
    ///xialei
    /// </summary>
    [Serializable]
    public struct GetParts
    {
        //参数定义	 		     
        public const string IDPARM = "@ID";
        public const string GUIDPARM = "@Guid";
        public const string CATEGORYIDPARM = "@CategoryID";
        public const string PARTSSUPPLIERIDPARM = "@PartsSupplierID";
        public const string WISETECHPARTSNOPARM = "@WisetechPartsNO";
        public const string SUPPLIERPARTSNOPARM = "@SupplierPartsNO";
        public const string PARTSNAMEPARM = "@PartsName";
        public const string PARTSDISPLAYNAMEPARM = "@PartsDisplayName";
        public const string MATERIALSPECIFICATIONPARM = "@MaterialSpecification";
        public const string PROCUREMENTPRICEPARM = "@ProcurementPrice";
        public const string PROCUREMENTCURRENCYPARM = "@ProcurementCurrency";
        public const string MARKETPRICEPARM = "@MarketPrice";
        public const string MARKETCURRENCYPARM = "@MarketCurrency";
        public const string GETGOODSDAYSPARM = "@GetGoodsDays";
        public const string PAYGOODSDAYSPARM = "@PayGoodsDays";
        public const string STOCKQUANTITYPARM = "@StockQuantity";
        public const string LEASTSELLCOUNTPARM = "@LeastSellCount";
        public const string REMARKPARM = "@Remark";
        public const string ISAVAILABLEPARM = "@IsAvailable";
        public const string CREATEBYPARM = "@CreateBy";
        public const string CREATETIMEPARM = "@CreateTime";
        public const string LASTMODIFYBYPARM = "@LastModifyBy";
        public const string LASTMODIFYTIMEPARM = "@LastModifyTime";
        public const string KEYVALUEPARM = "@KeyValue";
        public const string WISETECHPARTSNOKEYVALUEPARM = "@WisetechPartsNOKeyValue";
        public const string SUPPLIERPARTSNOKEYVALUEPARM = "@SupplierPartsNOKeyValue";
        public const string PROCUREMENTPRICESTARTPARM = "@ProcurementPriceStart";
        public const string PROCUREMENTPRICEENDPARM = "@ProcurementPriceEnd";
        public const string MARKETPRICESTARTPARM = "@MarketPriceStart";
        public const string MARKETPRICEENDPARM = "@MarketPriceEnd";
        public const string STOCKQUANTITYSTARTPARM = "@StockQuantityStart";
        public const string STOCKQUANTITYENDPARM = "@StockQuantityEnd";
        public const string PARTSMODELIDSPARM = "@PartsModelIDs";

        //分页参数定义  
        public const string ORDERSTRING_PARM = "@OrderString";
        public const string PAGESIZE_PARM = "@PageSize";
        public const string CURRENTPAGEINDEX_PARM = "@CurrentPageIndex";
        public const string TOTALITEMS_PARM = "@TotalItems";

        //字段属性设置
        private object ID;
        public object IDVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.ID); }
            set
            { this.ID = value; }
        }

        private object GUID;
        public object GUIDVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.GUID); }
            set
            { this.GUID = value; }
        }

        private object CategoryID;
        public object CATEGORYIDVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.CategoryID); }
            set
            { this.CategoryID = value; }
        }

        private object PartsSupplierID;
        public object PARTSSUPPLIERIDVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PartsSupplierID); }
            set
            { this.PartsSupplierID = value; }
        }

        private object WisetechPartsNO;
        public object WISETECHPARTSNOVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.WisetechPartsNO); }
            set
            { this.WisetechPartsNO = value; }
        }

        private object SupplierPartsNO;
        public object SUPPLIERPARTSNOVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.SupplierPartsNO); }
            set
            { this.SupplierPartsNO = value; }
        }

        private object PartsName;
        public object PARTSNAMEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PartsName); }
            set
            { this.PartsName = value; }
        }

        private object PartsDisplayName;
        public object PARTSDISPLAYNAMEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PartsDisplayName); }
            set
            { this.PartsDisplayName = value; }
        }

        private object MaterialSpecification;
        public object MATERIALSPECIFICATIONVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.MaterialSpecification); }
            set
            { this.MaterialSpecification = value; }
        }

        private object ProcurementPrice;
        public object PROCUREMENTPRICEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.ProcurementPrice); }
            set
            { this.ProcurementPrice = value; }
        }

        private object ProcurementCurrency;
        public object PROCUREMENTCURRENCYVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.ProcurementCurrency); }
            set
            { this.ProcurementCurrency = value; }
        }

        private object MarketPrice;
        public object MARKETPRICEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.MarketPrice); }
            set
            { this.MarketPrice = value; }
        }

        private object MarketCurrency;
        public object MARKETCURRENCYVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.MarketCurrency); }
            set
            { this.MarketCurrency = value; }
        }

        private object GetGoodsDays;
        public object GETGOODSDAYSVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.GetGoodsDays); }
            set
            { this.GetGoodsDays = value; }
        }

        private object PayGoodsDays;
        public object PAYGOODSDAYSVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PayGoodsDays); }
            set
            { this.PayGoodsDays = value; }
        }

        private object StockQuantity;
        public object STOCKQUANTITYVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.StockQuantity); }
            set
            { this.StockQuantity = value; }
        }

        private object LeastSellCount;
        public object LeastSellCountVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.LeastSellCount); }
            set
            { this.LeastSellCount = value; }
        }

        private object Remark;
        public object REMARKVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.Remark); }
            set
            { this.Remark = value; }
        }

        private object IsAvailable;
        public object ISAVAILABLEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.IsAvailable); }
            set
            { this.IsAvailable = value; }
        }

        private object CreateBy;
        public object CREATEBYVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.CreateBy); }
            set
            { this.CreateBy = value; }
        }

        private object CreateTime;
        public object CREATETIMEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.CreateTime); }
            set
            { this.CreateTime = value; }
        }

        private object LastModifyBy;
        public object LASTMODIFYBYVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.LastModifyBy); }
            set
            { this.LastModifyBy = value; }
        }

        private object LastModifyTime;
        public object LASTMODIFYTIMEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.LastModifyTime); }
            set
            { this.LastModifyTime = value; }
        }

        private object KeyValue;
        public object KEYVALUEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.KeyValue); }
            set
            { this.KeyValue = value; }
        }
        private object WisetechPartsNOKeyValue;
        public object WISETECHPARTSNOKEYVALUEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.WisetechPartsNOKeyValue); }
            set
            { this.WisetechPartsNOKeyValue = value; }
        }
        private object SupplierPartsNOKeyValue;
        public object SUPPLIERPARTSNOKEYVALUEVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.SupplierPartsNOKeyValue); }
            set
            { this.SupplierPartsNOKeyValue = value; }
        }
        private object ProcurementPriceStart;
        public object PROCUREMENTPRICESTARTVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.ProcurementPriceStart); }
            set
            { this.ProcurementPriceStart = value; }
        }
        private object ProcurementPriceEnd;
        public object PROCUREMENTPRICEENDVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.ProcurementPriceEnd); }
            set
            { this.ProcurementPriceEnd = value; }
        }
        private object MarketPriceStart;
        public object MARKETPRICESTARTVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.MarketPriceStart); }
            set
            { this.MarketPriceStart = value; }
        }
        private object MarketPriceEnd;
        public object MARKETPRICEENDVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.MarketPriceEnd); }
            set
            { this.MarketPriceEnd = value; }
        }
        private object StockQuantityStart;
        public object STOCKQUANTITYSTARTVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.StockQuantityStart); }
            set
            { this.StockQuantityStart = value; }
        }
        private object StockQuantityEnd;
        public object STOCKQUANTITYENDVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.StockQuantityEnd); }
            set
            { this.StockQuantityEnd = value; }
        }
        
        private object PartsModelIds;
        public object PARTSMODELIDSVALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PartsModelIds); }
            set
            { this.PartsModelIds = value; }
        }
        

        //分页属性设置
        private object OrderString;
        public object ORDERSTRING_VALUE
        {
            get { return CRM.UTIL.Common.TransQuote(this.OrderString); }
            set { this.OrderString = value; }
        }

        private object PageSize;
        public object PAGESIZE_VALUE
        {
            get { return CRM.UTIL.Common.TransValue(this.PageSize, CRM.UTIL.Common.DefaultPageSize); }
            set { this.PageSize = value; }
        }

        private object CurrentPageIndex;
        public object CURRENTPAGEINDEX_VALUE
        {
            get { return CRM.UTIL.Common.TransValue(this.CurrentPageIndex, CRM.UTIL.Common.DefaultCurrentPageIndex); }
            set { this.CurrentPageIndex = value; }
        }

        private object TotalItems;
        public object TOTALITEMS_VALUE
        {
            get { return CRM.UTIL.Common.TransValue(this.TotalItems); }
            set { this.TotalItems = value; }
        }

    }
    #endregion

    #region 存储过程 Pro_EditParts 的相关参数
    /// <summary>
    /// Pro_EditParts 的相关参数
    ///Parts
    ///xialei
    /// </summary>
    [Serializable]
    public struct EditParts
    {
        //动作参数
        public const string ACTION_PARM = "@Action";
        //错误信息参数
        public const string ERRMSG_PARM = "@errMsg";

        public const string OUTID_PARM = "@OutID";
        ////表字段参数
        public const string IDPARM = "@ID";
        public const string GUIDPARM = "@Guid";
        public const string CATEGORYIDPARM = "@CategoryID";
        public const string PARTSSUPPLIERIDPARM = "@PartsSupplierID";
        public const string WISETECHPARTSNOPARM = "@WisetechPartsNO";
        public const string SUPPLIERPARTSNOPARM = "@SupplierPartsNO";
        public const string PARTSNAMEPARM = "@PartsName";
        public const string PARTSDISPLAYNAMEPARM = "@PartsDisplayName";
        public const string MATERIALSPECIFICATIONPARM = "@MaterialSpecification";
        public const string PROCUREMENTPRICEPARM = "@ProcurementPrice";
        public const string PROCUREMENTCURRENCYPARM = "@ProcurementCurrency";
        public const string MARKETPRICEPARM = "@MarketPrice";
        public const string MARKETCURRENCYPARM = "@MarketCurrency";
        public const string GETGOODSDAYSPARM = "@GetGoodsDays";
        public const string PAYGOODSDAYSPARM = "@PayGoodsDays";
        public const string STOCKQUANTITYPARM = "@StockQuantity";
        public const string LEASTSELLCOUNTPARM = "@LeastSellCount";
        public const string REMARKPARM = "@Remark";
        public const string ISAVAILABLEPARM = "@IsAvailable";
        public const string CREATEBYPARM = "@CreateBy";
        public const string CREATETIMEPARM = "@CreateTime";
        public const string LASTMODIFYBYPARM = "@LastModifyBy";
        public const string LASTMODIFYTIMEPARM = "@LastModifyTime";


        //动作属性
        private object Action;
        public object ACTION_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.Action); }
            set
            { this.Action = value; }
        }

        //错误信息属性
        private object errMsg;
        public object ERRMSG_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.errMsg); }
            set
            { this.errMsg = value; }
        }

        private object OutID;
        public object OUTID_VALUE
        {
            get { return CRM.UTIL.Common.TransValue(this.OutID); }
            set { this.OutID = value; }
        }

        //表字段属性
        private object ID;
        public object ID_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.ID); }
            set
            { this.ID = value; }
        }
        private object GUID;
        public object GUID_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.GUID); }
            set
            { this.GUID = value; }
        }

        private object CategoryID;
        public object CATEGORYID_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.CategoryID); }
            set
            { this.CategoryID = value; }
        }

        private object PartsSupplierID;
        public object PARTSSUPPLIERID_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PartsSupplierID); }
            set
            { this.PartsSupplierID = value; }
        }

        private object WisetechPartsNO;
        public object WISETECHPARTSNO_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.WisetechPartsNO); }
            set
            { this.WisetechPartsNO = value; }
        }

        private object SupplierPartsNO;
        public object SUPPLIERPARTSNO_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.SupplierPartsNO); }
            set
            { this.SupplierPartsNO = value; }
        }

        private object PartsName;
        public object PARTSNAME_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PartsName); }
            set
            { this.PartsName = value; }
        }

        private object PartsDisplayName;
        public object PARTSDISPLAYNAME_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PartsDisplayName); }
            set
            { this.PartsDisplayName = value; }
        }

        private object MaterialSpecification;
        public object MATERIALSPECIFICATION_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.MaterialSpecification); }
            set
            { this.MaterialSpecification = value; }
        }

        private object ProcurementPrice;
        public object PROCUREMENTPRICE_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.ProcurementPrice); }
            set
            { this.ProcurementPrice = value; }
        }

        private object ProcurementCurrency;
        public object PROCUREMENTCURRENCY_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.ProcurementCurrency); }
            set
            { this.ProcurementCurrency = value; }
        }

        private object MarketPrice;
        public object MARKETPRICE_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.MarketPrice); }
            set
            { this.MarketPrice = value; }
        }

        private object MarketCurrency;
        public object MARKETCURRENCY_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.MarketCurrency); }
            set
            { this.MarketCurrency = value; }
        }

        private object GetGoodsDays;
        public object GETGOODSDAYS_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.GetGoodsDays); }
            set
            { this.GetGoodsDays = value; }
        }

        private object PayGoodsDays;
        public object PAYGOODSDAYS_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.PayGoodsDays); }
            set
            { this.PayGoodsDays = value; }
        }

        private object StockQuantity;
        public object STOCKQUANTITY_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.StockQuantity); }
            set
            { this.StockQuantity = value; }
        }
        private object LeastSellCount;
        public object LEASTSELLCOUNT_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.LeastSellCount); }
            set
            { this.LeastSellCount = value; }
        }

        private object Remark;
        public object REMARK_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.Remark); }
            set
            { this.Remark = value; }
        }

        private object IsAvailable;
        public object ISAVAILABLE_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.IsAvailable); }
            set
            { this.IsAvailable = value; }
        }

        private object CreateBy;
        public object CREATEBY_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.CreateBy); }
            set
            { this.CreateBy = value; }
        }

        private object CreateTime;
        public object CREATETIME_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.CreateTime); }
            set
            { this.CreateTime = value; }
        }

        private object LastModifyBy;
        public object LASTMODIFYBY_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.LastModifyBy); }
            set
            { this.LastModifyBy = value; }
        }

        private object LastModifyTime;
        public object LASTMODIFYTIME_VALUE
        {
            get
            { return CRM.UTIL.Common.TransValue(this.LastModifyTime); }
            set
            { this.LastModifyTime = value; }
        }

    }
    #endregion
}
